Problem Note 46806: Authorization error might occur when opening an information map table in SAS® Enterprise Guide® or the SAS® Add-In for Microsoft Office
When opening an information map in SAS Enterprise Guide or the SAS Add-In for Microsoft Office, you might see the following error:
ERROR: The GET routine failed to fetch data from the cursor.
ERROR: User not authorized to access data source for information map.
This error is most likely to appear if you are running SAS® 9.3 or 9.3_M1.
Beginning in SAS 9.3, Read permission is required on the table that is being used as the input data source (table) for the information map. For example, say that you have an information map named "Student Data". The input data source for that information map might be the CLASS table in the SASHELP library. The user who is logged into SAS Enterprise Guide or the SAS Add-In needs Read permission specifically on the CLASS table.
There are three ways to resolve this issue:
- If you are running 9.3_M1, you can install the two hot fixes that are available from the Hot Fix tab in this SAS note.
- You can install maintenance 2 for SAS 9.3. For more information, see Maintenance Releases and Product Upgrades.
- You can use SAS® Management Console to navigate to the table and grant explicit Read permission to the users or groups who need to open the information map in SAS Enterprise Guide or the SAS Add-In.
Note: If the pooled workspace server is being used to access the information map, then you must make sure that the launch credentials used for the pooled workspace server are given Read permission to the table. For example, the pooled workspace server is used if the logged in user does not have operating system permissions to the underlying table.
Change in behavior from SAS 9.2
In SAS 9.2, you could perform the following tasks to restrict access to data based on identity.
- Create an information map with identity-driven, row-level permissions.
- Register the information map as a table in metadata.
- Open the filtered information map table in SAS Enterprise Guide or the SAS Add-In for Microsoft Office.
You achieved this result by denying Read permission to the table used as input to the information map. After upgrading to SAS 9.3, this solution no longer works. You must use one of resolutions in this SAS Note to regain the functionality from SAS 9.2
Operating System and Release Information
SAS System | Base SAS | Solaris for x64 | 9.3 TS1M0 | 9.3 TS1M2 |
Linux for x64 | 9.3 TS1M0 | 9.3 TS1M2 |
Linux | 9.3 TS1M0 | 9.3 TS1M2 |
HP-UX IPF | 9.3 TS1M0 | 9.3 TS1M2 |
Windows 7 Enterprise x64 | 9.3 TS1M0 | 9.3 TS1M2 |
Windows 7 Enterprise 32 bit | 9.3 TS1M0 | 9.3 TS1M2 |
Microsoft Windows XP Professional | 9.3 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2008 | 9.3 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | 9.3 TS1M2 |
Microsoft® Windows® for x64 | 9.3 TS1M0 | 9.3 TS1M2 |
64-bit Enabled Solaris | 9.3 TS1M0 | 9.3 TS1M2 |
64-bit Enabled HP-UX | 9.3 TS1M0 | 9.3 TS1M2 |
64-bit Enabled AIX | 9.3 TS1M0 | 9.3 TS1M2 |
Windows Vista for x64 | 9.3 TS1M0 | 9.3 TS1M2 |
Windows Vista | 9.3 TS1M0 | 9.3 TS1M2 |
Windows 7 Ultimate x64 | 9.3 TS1M0 | 9.3 TS1M2 |
Windows 7 Ultimate 32 bit | 9.3 TS1M0 | 9.3 TS1M2 |
Windows 7 Professional x64 | 9.3 TS1M0 | 9.3 TS1M2 |
Windows 7 Professional 32 bit | 9.3 TS1M0 | 9.3 TS1M2 |
Windows 7 Home Premium x64 | 9.3 TS1M0 | 9.3 TS1M2 |
Windows 7 Home Premium 32 bit | 9.3 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | 9.3 TS1M2 |
z/OS | 9.3 TS1M0 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2012-06-13 16:31:32 |
Date Created: | 2012-06-13 16:20:35 |